|
RAIS
3.2
|
00001 00002 00003 00004 using System; 00005 using System.Collections.Generic; 00006 using System.Data; 00007 namespace RAIS.Common.RADEVClasses 00008 { 00009 public class EventWorkerPublicCauses:RADEVTable 00010 { 00011 #region Fields 00012 //protected const string commandString = "SELECT * FROM EventWorkerPublicCauses"; 00013 protected const string commandString = "SELECT * FROM [RADEV Report - Event Causes]()"; 00014 protected const string sourceName = "RADEVData_EventWorkerPublicCauses"; 00015 private static List<RADEVTable> data = new List<RADEVTable>(); 00016 00017 string _cause = ""; 00018 string _causeNumber = ""; 00019 #endregion 00020 #region Properties 00021 00022 00023 00024 public string Cause { get { return _cause; } } 00028 public string CauseNumber { get { return _causeNumber; } } 00029 #endregion 00030 #region Public methods 00031 00032 00033 00034 00035 public static RADEVTable CreateInstatce() 00036 { 00037 data.Clear(); 00038 return new EventWorkerPublicCauses(); 00039 } 00044 public override List<RADEVTable> GetData() 00045 { 00046 return data; 00047 } 00052 public override string GetSourceName() 00053 { 00054 return sourceName; 00055 } 00061 public override bool IsValid(RADEVCriterias criterias) 00062 { 00063 return criterias.IAEAEventID == IAEAEventID; 00064 } 00065 #endregion 00066 #region Protected methods 00067 protected override void AddNewRow(IDataReader reader) 00068 { 00069 data.Add(new EventWorkerPublicCauses(reader)); 00070 } 00071 protected override string GetCommandString() 00072 { 00073 return commandString; 00074 } 00075 #endregion 00076 #region Constructors 00077 private EventWorkerPublicCauses() { } 00078 00079 public EventWorkerPublicCauses(IDataReader reader) 00080 : base((string)reader["IAEAEventID"]) 00081 { 00082 _cause = reader["Cause"] is DBNull ? "" : reader["Cause"].ToString(); 00083 _causeNumber = reader["CauseNumber"] is DBNull ? "" : reader["CauseNumber"].ToString(); 00084 } 00085 #endregion 00086 00087 } 00088 }